Tabela PhLotHist

Definicja tabeli PhLotHist

Name

PhLotHist

Code

PhLotHist

Comment

Dostawy/serie leku


Lista kolumn tabeli PhLotHist

Name

Code

REV

REV

RevTypeID

RevTypeID

LotID

LotID

StItemID

StItemID

BlockadeLotID

BlockadeLotID

LotTypeID

LotTypeID

LotNumber

LotNumber

ProdDT

ProdDT

ValidityDT

ValidityDT

DeliveryDT

DeliveryDT

Blocked

Blocked

PriceGross

PriceGross

PriceNet

PriceNet

Active

Active

BlockedDT

BlockedDT

DelivererID

DelivererID

PatientID

PatientID

VatRateID

VatRateID

Ean

Ean

Comments

Comments

TradeDocNo

TradeDocNo

TradeDocItemNo

TradeDocItemNo

Nip

Nip

TradeDocumentDT

TradeDocumentDT

Version

Version

CorrectionNote

CorrectionNote

IP

IP

OrgTradeDocNo

OrgTradeDocNo

OrgTradeDocItemNo

OrgTradeDocItemNo

OrgTradeDocDT

OrgTradeDocDT


Kolumna REV tabeli PhLotHist

Definicja kolumny REV tabeli PhLotHist

Name

REV

Code

REV

Data Type

NUMBER(10)

Mandatory

No

Comment

ID rewizji


Kolumna RevTypeID tabeli PhLotHist

Definicja kolumny RevTypeID tabeli PhLotHist

Name

RevTypeID

Code

RevTypeID

Data Type

NUMBER(3)

Mandatory

No

Comment

Typ zmiany


Kolumna LotID tabeli PhLotHist

Definicja kolumny LotID tabeli PhLotHist

Name

LotID

Code

LotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID serii leku


Kolumna StItemID tabeli PhLotHist

Definicja kolumny StItemID tabeli PhLotHist

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BlockadeLotID tabeli PhLotHist

Definicja kolumny BlockadeLotID tabeli PhLotHist

Name

BlockadeLotID

Code

BlockadeLotID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LotTypeID tabeli PhLotHist

Definicja kolumny LotTypeID tabeli PhLotHist

Name

LotTypeID

Code

LotTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LotNumber tabeli PhLotHist

Definicja kolumny LotNumber tabeli PhLotHist

Name

LotNumber

Code

LotNumber

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer serii


Kolumna ProdDT tabeli PhLotHist

Definicja kolumny ProdDT tabeli PhLotHist

Name

ProdDT

Code

ProdDT

Data Type

DATE

Mandatory

No

Comment

Data produkcji


Kolumna ValidityDT tabeli PhLotHist

Definicja kolumny ValidityDT tabeli PhLotHist

Name

ValidityDT

Code

ValidityDT

Data Type

DATE

Mandatory

No

Comment

Data waznosci


Kolumna DeliveryDT tabeli PhLotHist

Definicja kolumny DeliveryDT tabeli PhLotHist

Name

DeliveryDT

Code

DeliveryDT

Data Type

DATE

Mandatory

No

Comment

Data dostawy


Kolumna Blocked tabeli PhLotHist

Definicja kolumny Blocked tabeli PhLotHist

Name

Blocked

Code

Blocked

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga zablokowania


Kolumna PriceGross tabeli PhLotHist

Definicja kolumny PriceGross tabeli PhLotHist

Name

PriceGross

Code

PriceGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena brutto


Kolumna PriceNet tabeli PhLotHist

Definicja kolumny PriceNet tabeli PhLotHist

Name

PriceNet

Code

PriceNet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena netto


Kolumna Active tabeli PhLotHist

Definicja kolumny Active tabeli PhLotHist

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w systemie


Kolumna BlockedDT tabeli PhLotHist

Definicja kolumny BlockedDT tabeli PhLotHist

Name

BlockedDT

Code

BlockedDT

Data Type

DATE

Mandatory

No

Comment

Data blokady


Kolumna DelivererID tabeli PhLotHist

Definicja kolumny DelivererID tabeli PhLotHist

Name

DelivererID

Code

DelivererID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID dostawcy


Kolumna PatientID tabeli PhLotHist

Definicja kolumny PatientID tabeli PhLotHist

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wskazanie na pacjenta dla funkcjonalnosci "Leki pacjenta"


Kolumna VatRateID tabeli PhLotHist

Definicja kolumny VatRateID tabeli PhLotHist

Name

VatRateID

Code

VatRateID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID stawki VAT dla danej dostawy asortymentu


Kolumna Ean tabeli PhLotHist

Definicja kolumny Ean tabeli PhLotHist

Name

Ean

Code

Ean

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod EAN dla serii leków


Kolumna Comments tabeli PhLotHist

Definicja kolumny Comments tabeli PhLotHist

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TradeDocNo tabeli PhLotHist

Definicja kolumny TradeDocNo tabeli PhLotHist

Name

TradeDocNo

Code

TradeDocNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer faktury, z która dostawa weszla na stan


Kolumna TradeDocItemNo tabeli PhLotHist

Definicja kolumny TradeDocItemNo tabeli PhLotHist

Name

TradeDocItemNo

Code

TradeDocItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Numer pozycji na fakturze, z która dostawa weszla na stan


Kolumna Nip tabeli PhLotHist

Definicja kolumny Nip tabeli PhLotHist

Name

Nip

Code

Nip

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TradeDocumentDT tabeli PhLotHist

Definicja kolumny TradeDocumentDT tabeli PhLotHist

Name

TradeDocumentDT

Code

TradeDocumentDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Version tabeli PhLotHist

Definicja kolumny Version tabeli PhLotHist

Name

Version

Code

Version

Data Type

NUMBER(10)

Mandatory

Yes

Comment

wersja obiektu do zarzadzania wielowatkowym


Kolumna CorrectionNote tabeli PhLotHist

Definicja kolumny CorrectionNote tabeli PhLotHist

Name

CorrectionNote

Code

CorrectionNote

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Numer noty korygujacej


Kolumna IP tabeli PhLotHist

Definicja kolumny IP tabeli PhLotHist

Name

IP

Code

IP

Data Type

VARCHAR2(39)

Mandatory

No

Comment

Adres IP z którego ostatnio modyfikowano dokument lub serie asortymentu.


Kolumna OrgTradeDocNo tabeli PhLotHist

Definicja kolumny OrgTradeDocNo tabeli PhLotHist

Name

OrgTradeDocNo

Code

OrgTradeDocNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

numer faktury pierwotnej


Kolumna OrgTradeDocItemNo tabeli PhLotHist

Definicja kolumny OrgTradeDocItemNo tabeli PhLotHist

Name

OrgTradeDocItemNo

Code

OrgTradeDocItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

numer pozycji na fakturze pierwotnej


Kolumna OrgTradeDocDT tabeli PhLotHist

Definicja kolumny OrgTradeDocDT tabeli PhLotHist

Name

OrgTradeDocDT

Code

OrgTradeDocDT

Data Type

DATE

Mandatory

No

Comment

data faktury pierwotnej